📍Telephonic Round (Screening)

Round 1 – Technical Assessment (30 minutes)

📍 8 SQL questions (easy to medium level).

📍 Focused on writing queries efficiently and accurately.

Round 2 – Hiring Manager

📍 Basic questions on Snowflake and understanding its core features.

📍 Questions related to data modeling, specifically the stages of the Medallion Architecture.

📍 SQL query execution and optimization.

📍 One easy to medium-level JOIN question.

📍 One Python question – likely involving string/list operations (e.g., counting the frequency of words in a list).

📍 Discussed my previous organization’s project, the challenges I faced, and how I resolved them.

Round 3 – Client

📍 Questions related to Data Warehousing concepts.

📍 Basic to medium-level knowledge check on Snowflake.

📍 Detailed discussion on my previous project, followed by cross-questions to assess depth of understanding.

Suggestion - I suggest practicing SQL questions on LeetCode, especially common patterns like N-th rank, employee-manager hierarchy, and ranking functions (RANK(), ROW_NUMBER(), etc.).

For Python, focus on basic string and list operations such as reversing a string and counting word frequency.

Also, understand the stages of data transformation (like the Medallion Architecture) and build a solid grasp of Snowflake basics, including its architecture and key features.